# Import excel
import pandas
import xlrd
df = pandas.read_excel('C:\\Users\\Subhojit\\Desktop\\SAS class\\1.xlsx',
sheet_name="1")
df

Tha above code read_excel doesn't work any more. Read below:





https://strategyanalytics.medium.com/pandas-read-excel-removed-support-for-xlsx-files-426e4acfde89

Pandas read_excel removed support for xlsx files




#This works now. Install openpyxl with pip install

import openpyxl
import os
os.chdir("C:\\Users\\USER\\Desktop\\Python\\Class 1")
pd.read_excel("data_excel.xlsx", engine = 'openpyxl')
